﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create PROCEDURE [dbo].[proc_SF_CE20150115]
	-- Add the parameters for the stored procedure here
	(@CompanyId INT , 
	@CreateDate VARCHAR(10)
	)
AS
BEGIN
	
	Declare @sRq Datetime,@eRq Datetime
	Set @sRq = Convert(Datetime, @CreateDate + ' 00:00:00')
	Set @eRq = Convert(Datetime, @CreateDate + ' 23:59:59')
	
	select * from [Statistics_Financial_CE] where companyid=@CompanyId and createdate between @sRq and @eRq
	
END
